package com.ecoolex.discount.sales.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class YWGiftCardOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public YWGiftCardOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public YWGiftCardOrderExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public YWGiftCardOrderExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        YWGiftCardOrderExample example = new YWGiftCardOrderExample();
        return example.createCriteria();
    }

    public YWGiftCardOrderExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public YWGiftCardOrderExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public YWGiftCardOrderExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public YWGiftCardOrderExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public YWGiftCardOrderExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ywgiftcardorder.Id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ywgiftcardorder.Id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.Id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Id = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.Id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Id <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ywgiftcardorder.Id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Id > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.Id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Id >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ywgiftcardorder.Id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Id < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.Id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Id <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ywgiftcardorder.Id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ywgiftcardorder.Id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ywgiftcardorder.Id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ywgiftcardorder.Id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andChannelIdIsNull() {
            addCriterion("ywgiftcardorder.ChannelId is null");
            return (Criteria) this;
        }

        public Criteria andChannelIdIsNotNull() {
            addCriterion("ywgiftcardorder.ChannelId is not null");
            return (Criteria) this;
        }

        public Criteria andChannelIdEqualTo(String value) {
            addCriterion("ywgiftcardorder.ChannelId =", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.ChannelId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andChannelIdNotEqualTo(String value) {
            addCriterion("ywgiftcardorder.ChannelId <>", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.ChannelId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andChannelIdGreaterThan(String value) {
            addCriterion("ywgiftcardorder.ChannelId >", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.ChannelId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andChannelIdGreaterThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.ChannelId >=", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.ChannelId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andChannelIdLessThan(String value) {
            addCriterion("ywgiftcardorder.ChannelId <", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.ChannelId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andChannelIdLessThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.ChannelId <=", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.ChannelId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andChannelIdLike(String value) {
            addCriterion("ywgiftcardorder.ChannelId like", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotLike(String value) {
            addCriterion("ywgiftcardorder.ChannelId not like", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdIn(List<String> values) {
            addCriterion("ywgiftcardorder.ChannelId in", values, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotIn(List<String> values) {
            addCriterion("ywgiftcardorder.ChannelId not in", values, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.ChannelId between", value1, value2, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.ChannelId not between", value1, value2, "channelId");
            return (Criteria) this;
        }

        public Criteria andServiceIdIsNull() {
            addCriterion("ywgiftcardorder.ServiceId is null");
            return (Criteria) this;
        }

        public Criteria andServiceIdIsNotNull() {
            addCriterion("ywgiftcardorder.ServiceId is not null");
            return (Criteria) this;
        }

        public Criteria andServiceIdEqualTo(String value) {
            addCriterion("ywgiftcardorder.ServiceId =", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.ServiceId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceIdNotEqualTo(String value) {
            addCriterion("ywgiftcardorder.ServiceId <>", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.ServiceId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceIdGreaterThan(String value) {
            addCriterion("ywgiftcardorder.ServiceId >", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.ServiceId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceIdGreaterThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.ServiceId >=", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.ServiceId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceIdLessThan(String value) {
            addCriterion("ywgiftcardorder.ServiceId <", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.ServiceId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceIdLessThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.ServiceId <=", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.ServiceId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceIdLike(String value) {
            addCriterion("ywgiftcardorder.ServiceId like", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdNotLike(String value) {
            addCriterion("ywgiftcardorder.ServiceId not like", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdIn(List<String> values) {
            addCriterion("ywgiftcardorder.ServiceId in", values, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdNotIn(List<String> values) {
            addCriterion("ywgiftcardorder.ServiceId not in", values, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.ServiceId between", value1, value2, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdNotBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.ServiceId not between", value1, value2, "serviceId");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("ywgiftcardorder.UserId is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("ywgiftcardorder.UserId is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(String value) {
            addCriterion("ywgiftcardorder.UserId =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UserId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(String value) {
            addCriterion("ywgiftcardorder.UserId <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UserId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(String value) {
            addCriterion("ywgiftcardorder.UserId >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UserId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.UserId >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UserId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(String value) {
            addCriterion("ywgiftcardorder.UserId <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UserId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.UserId <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UserId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLike(String value) {
            addCriterion("ywgiftcardorder.UserId like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotLike(String value) {
            addCriterion("ywgiftcardorder.UserId not like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<String> values) {
            addCriterion("ywgiftcardorder.UserId in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<String> values) {
            addCriterion("ywgiftcardorder.UserId not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.UserId between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.UserId not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNull() {
            addCriterion("ywgiftcardorder.Phone is null");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNotNull() {
            addCriterion("ywgiftcardorder.Phone is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualTo(String value) {
            addCriterion("ywgiftcardorder.Phone =", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Phone = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualTo(String value) {
            addCriterion("ywgiftcardorder.Phone <>", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Phone <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThan(String value) {
            addCriterion("ywgiftcardorder.Phone >", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Phone > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.Phone >=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Phone >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPhoneLessThan(String value) {
            addCriterion("ywgiftcardorder.Phone <", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Phone < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.Phone <=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Phone <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPhoneLike(String value) {
            addCriterion("ywgiftcardorder.Phone like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotLike(String value) {
            addCriterion("ywgiftcardorder.Phone not like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneIn(List<String> values) {
            addCriterion("ywgiftcardorder.Phone in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotIn(List<String> values) {
            addCriterion("ywgiftcardorder.Phone not in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.Phone between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.Phone not between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("ywgiftcardorder.OrderNo is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("ywgiftcardorder.OrderNo is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("ywgiftcardorder.OrderNo =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.OrderNo = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("ywgiftcardorder.OrderNo <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.OrderNo <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("ywgiftcardorder.OrderNo >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.OrderNo > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.OrderNo >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.OrderNo >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("ywgiftcardorder.OrderNo <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.OrderNo < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.OrderNo <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.OrderNo <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("ywgiftcardorder.OrderNo like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("ywgiftcardorder.OrderNo not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("ywgiftcardorder.OrderNo in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("ywgiftcardorder.OrderNo not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.OrderNo between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.OrderNo not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNull() {
            addCriterion("ywgiftcardorder.Currency is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNotNull() {
            addCriterion("ywgiftcardorder.Currency is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.Currency =", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Currency = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyNotEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.Currency <>", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Currency <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThan(Integer value) {
            addCriterion("ywgiftcardorder.Currency >", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Currency > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThanOrEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.Currency >=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Currency >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThan(Integer value) {
            addCriterion("ywgiftcardorder.Currency <", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Currency < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThanOrEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.Currency <=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Currency <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyIn(List<Integer> values) {
            addCriterion("ywgiftcardorder.Currency in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotIn(List<Integer> values) {
            addCriterion("ywgiftcardorder.Currency not in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyBetween(Integer value1, Integer value2) {
            addCriterion("ywgiftcardorder.Currency between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotBetween(Integer value1, Integer value2) {
            addCriterion("ywgiftcardorder.Currency not between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("ywgiftcardorder.`Status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("ywgiftcardorder.`Status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.`Status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.`Status` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.`Status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.`Status` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("ywgiftcardorder.`Status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.`Status` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.`Status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.`Status` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("ywgiftcardorder.`Status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.`Status` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.`Status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.`Status` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("ywgiftcardorder.`Status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("ywgiftcardorder.`Status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("ywgiftcardorder.`Status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("ywgiftcardorder.`Status` not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNull() {
            addCriterion("ywgiftcardorder.PaymentTime is null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNotNull() {
            addCriterion("ywgiftcardorder.PaymentTime is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeEqualTo(String value) {
            addCriterion("ywgiftcardorder.PaymentTime =", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.PaymentTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotEqualTo(String value) {
            addCriterion("ywgiftcardorder.PaymentTime <>", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.PaymentTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThan(String value) {
            addCriterion("ywgiftcardorder.PaymentTime >", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.PaymentTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.PaymentTime >=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.PaymentTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThan(String value) {
            addCriterion("ywgiftcardorder.PaymentTime <", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.PaymentTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.PaymentTime <=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.PaymentTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLike(String value) {
            addCriterion("ywgiftcardorder.PaymentTime like", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotLike(String value) {
            addCriterion("ywgiftcardorder.PaymentTime not like", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIn(List<String> values) {
            addCriterion("ywgiftcardorder.PaymentTime in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotIn(List<String> values) {
            addCriterion("ywgiftcardorder.PaymentTime not in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.PaymentTime between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.PaymentTime not between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentNoIsNull() {
            addCriterion("ywgiftcardorder.PaymentNo is null");
            return (Criteria) this;
        }

        public Criteria andPaymentNoIsNotNull() {
            addCriterion("ywgiftcardorder.PaymentNo is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentNoEqualTo(String value) {
            addCriterion("ywgiftcardorder.PaymentNo =", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.PaymentNo = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotEqualTo(String value) {
            addCriterion("ywgiftcardorder.PaymentNo <>", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.PaymentNo <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThan(String value) {
            addCriterion("ywgiftcardorder.PaymentNo >", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.PaymentNo > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.PaymentNo >=", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.PaymentNo >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThan(String value) {
            addCriterion("ywgiftcardorder.PaymentNo <", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.PaymentNo < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.PaymentNo <=", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.PaymentNo <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoLike(String value) {
            addCriterion("ywgiftcardorder.PaymentNo like", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotLike(String value) {
            addCriterion("ywgiftcardorder.PaymentNo not like", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoIn(List<String> values) {
            addCriterion("ywgiftcardorder.PaymentNo in", values, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotIn(List<String> values) {
            addCriterion("ywgiftcardorder.PaymentNo not in", values, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.PaymentNo between", value1, value2, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.PaymentNo not between", value1, value2, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIsNull() {
            addCriterion("ywgiftcardorder.OrderTime is null");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIsNotNull() {
            addCriterion("ywgiftcardorder.OrderTime is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTimeEqualTo(String value) {
            addCriterion("ywgiftcardorder.OrderTime =", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.OrderTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotEqualTo(String value) {
            addCriterion("ywgiftcardorder.OrderTime <>", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.OrderTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThan(String value) {
            addCriterion("ywgiftcardorder.OrderTime >", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.OrderTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.OrderTime >=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.OrderTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThan(String value) {
            addCriterion("ywgiftcardorder.OrderTime <", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.OrderTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.OrderTime <=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.OrderTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderTimeLike(String value) {
            addCriterion("ywgiftcardorder.OrderTime like", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotLike(String value) {
            addCriterion("ywgiftcardorder.OrderTime not like", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIn(List<String> values) {
            addCriterion("ywgiftcardorder.OrderTime in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotIn(List<String> values) {
            addCriterion("ywgiftcardorder.OrderTime not in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.OrderTime between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.OrderTime not between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria andCardIdIsNull() {
            addCriterion("ywgiftcardorder.CardId is null");
            return (Criteria) this;
        }

        public Criteria andCardIdIsNotNull() {
            addCriterion("ywgiftcardorder.CardId is not null");
            return (Criteria) this;
        }

        public Criteria andCardIdEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.CardId =", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CardId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardIdNotEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.CardId <>", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CardId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardIdGreaterThan(Integer value) {
            addCriterion("ywgiftcardorder.CardId >", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CardId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.CardId >=", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CardId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardIdLessThan(Integer value) {
            addCriterion("ywgiftcardorder.CardId <", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CardId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardIdLessThanOrEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.CardId <=", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CardId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardIdIn(List<Integer> values) {
            addCriterion("ywgiftcardorder.CardId in", values, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdNotIn(List<Integer> values) {
            addCriterion("ywgiftcardorder.CardId not in", values, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdBetween(Integer value1, Integer value2) {
            addCriterion("ywgiftcardorder.CardId between", value1, value2, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ywgiftcardorder.CardId not between", value1, value2, "cardId");
            return (Criteria) this;
        }

        public Criteria andBuyNumberIsNull() {
            addCriterion("ywgiftcardorder.BuyNumber is null");
            return (Criteria) this;
        }

        public Criteria andBuyNumberIsNotNull() {
            addCriterion("ywgiftcardorder.BuyNumber is not null");
            return (Criteria) this;
        }

        public Criteria andBuyNumberEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.BuyNumber =", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.BuyNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberNotEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.BuyNumber <>", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.BuyNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberGreaterThan(Integer value) {
            addCriterion("ywgiftcardorder.BuyNumber >", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.BuyNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.BuyNumber >=", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.BuyNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberLessThan(Integer value) {
            addCriterion("ywgiftcardorder.BuyNumber <", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.BuyNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberLessThanOrEqualTo(Integer value) {
            addCriterion("ywgiftcardorder.BuyNumber <=", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.BuyNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberIn(List<Integer> values) {
            addCriterion("ywgiftcardorder.BuyNumber in", values, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberNotIn(List<Integer> values) {
            addCriterion("ywgiftcardorder.BuyNumber not in", values, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberBetween(Integer value1, Integer value2) {
            addCriterion("ywgiftcardorder.BuyNumber between", value1, value2, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("ywgiftcardorder.BuyNumber not between", value1, value2, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andRealPriceIsNull() {
            addCriterion("ywgiftcardorder.RealPrice is null");
            return (Criteria) this;
        }

        public Criteria andRealPriceIsNotNull() {
            addCriterion("ywgiftcardorder.RealPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRealPriceEqualTo(BigDecimal value) {
            addCriterion("ywgiftcardorder.RealPrice =", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.RealPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceNotEqualTo(BigDecimal value) {
            addCriterion("ywgiftcardorder.RealPrice <>", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.RealPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThan(BigDecimal value) {
            addCriterion("ywgiftcardorder.RealPrice >", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.RealPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ywgiftcardorder.RealPrice >=", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.RealPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThan(BigDecimal value) {
            addCriterion("ywgiftcardorder.RealPrice <", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.RealPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ywgiftcardorder.RealPrice <=", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.RealPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceIn(List<BigDecimal> values) {
            addCriterion("ywgiftcardorder.RealPrice in", values, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceNotIn(List<BigDecimal> values) {
            addCriterion("ywgiftcardorder.RealPrice not in", values, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ywgiftcardorder.RealPrice between", value1, value2, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ywgiftcardorder.RealPrice not between", value1, value2, "realPrice");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentIsNull() {
            addCriterion("ywgiftcardorder.CardDiscountPercent is null");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentIsNotNull() {
            addCriterion("ywgiftcardorder.CardDiscountPercent is not null");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentEqualTo(BigDecimal value) {
            addCriterion("ywgiftcardorder.CardDiscountPercent =", value, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CardDiscountPercent = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentNotEqualTo(BigDecimal value) {
            addCriterion("ywgiftcardorder.CardDiscountPercent <>", value, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CardDiscountPercent <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentGreaterThan(BigDecimal value) {
            addCriterion("ywgiftcardorder.CardDiscountPercent >", value, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CardDiscountPercent > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ywgiftcardorder.CardDiscountPercent >=", value, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CardDiscountPercent >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentLessThan(BigDecimal value) {
            addCriterion("ywgiftcardorder.CardDiscountPercent <", value, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CardDiscountPercent < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ywgiftcardorder.CardDiscountPercent <=", value, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CardDiscountPercent <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentIn(List<BigDecimal> values) {
            addCriterion("ywgiftcardorder.CardDiscountPercent in", values, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentNotIn(List<BigDecimal> values) {
            addCriterion("ywgiftcardorder.CardDiscountPercent not in", values, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ywgiftcardorder.CardDiscountPercent between", value1, value2, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ywgiftcardorder.CardDiscountPercent not between", value1, value2, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceIsNull() {
            addCriterion("ywgiftcardorder.DiscountPrice is null");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceIsNotNull() {
            addCriterion("ywgiftcardorder.DiscountPrice is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceEqualTo(BigDecimal value) {
            addCriterion("ywgiftcardorder.DiscountPrice =", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.DiscountPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotEqualTo(BigDecimal value) {
            addCriterion("ywgiftcardorder.DiscountPrice <>", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.DiscountPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountPriceGreaterThan(BigDecimal value) {
            addCriterion("ywgiftcardorder.DiscountPrice >", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.DiscountPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ywgiftcardorder.DiscountPrice >=", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.DiscountPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountPriceLessThan(BigDecimal value) {
            addCriterion("ywgiftcardorder.DiscountPrice <", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.DiscountPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ywgiftcardorder.DiscountPrice <=", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.DiscountPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountPriceIn(List<BigDecimal> values) {
            addCriterion("ywgiftcardorder.DiscountPrice in", values, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotIn(List<BigDecimal> values) {
            addCriterion("ywgiftcardorder.DiscountPrice not in", values, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ywgiftcardorder.DiscountPrice between", value1, value2, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ywgiftcardorder.DiscountPrice not between", value1, value2, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("ywgiftcardorder.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("ywgiftcardorder.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("ywgiftcardorder.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("ywgiftcardorder.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("ywgiftcardorder.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("ywgiftcardorder.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("ywgiftcardorder.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("ywgiftcardorder.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("ywgiftcardorder.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("ywgiftcardorder.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("ywgiftcardorder.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("ywgiftcardorder.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("ywgiftcardorder.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("ywgiftcardorder.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("ywgiftcardorder.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("ywgiftcardorder.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("ywgiftcardorder.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("ywgiftcardorder.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("ywgiftcardorder.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("ywgiftcardorder.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("ywgiftcardorder.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("ywgiftcardorder.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("ywgiftcardorder.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("ywgiftcardorder.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("ywgiftcardorder.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("ywgiftcardorder.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("ywgiftcardorder.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ywgiftcardorder.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("ywgiftcardorder.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("ywgiftcardorder.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("ywgiftcardorder.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("ywgiftcardorder.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("ywgiftcardorder.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("ywgiftcardorder.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("ywgiftcardorder.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("ywgiftcardorder.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("ywgiftcardorder.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("ywgiftcardorder.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("ywgiftcardorder.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("ywgiftcardorder.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("ywgiftcardorder.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("ywgiftcardorder.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("ywgiftcardorder.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("ywgiftcardorder.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("ywgiftcardorder.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("ywgiftcardorder.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("ywgiftcardorder.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("ywgiftcardorder.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("ywgiftcardorder.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("ywgiftcardorder.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("ywgiftcardorder.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ywgiftcardorder.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("ywgiftcardorder.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("ywgiftcardorder.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(YWGiftCardOrder.Column column) {
            addCriterion(new StringBuilder("ywgiftcardorder.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("ywgiftcardorder.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("ywgiftcardorder.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("ywgiftcardorder.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("ywgiftcardorder.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private YWGiftCardOrderExample example;

        protected Criteria(YWGiftCardOrderExample example) {
            super();
            this.example = example;
        }

        public YWGiftCardOrderExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(YWGiftCardOrder.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(YWGiftCardOrder.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.discount.sales.entity.YWGiftCardOrderExample example);
    }
}